ASP 代码不能执行`

来源：百度知道 编辑：UC知道 时间：2024/05/14 11:44:50
<%
f_user1=request.form("f_user")
f_code=request.form("f_code")
f_name=request.Form("f_name")
f_sfz=request.Form("f_sfz")
f_emall=request.Form("f_emall")

set rst=server.CreateObject("ADODB.recordset")
sql="Select * From users where f_user='"&f_user1&"'"
rst.open sql,conn,1,1
if rst.eof and rst.bof then
response.write("<script> alert('用户名已被注册!');history.back(-1);</script> ")
response.end

else

rst1="insert into users(f_user,f_code) values('"+f_user1+"','"+f_code+"')"
rst2="insert into infor(f_name,f_sfz,f_emall) values('"+f_name+"','"+f_sfz+"','"+f_emall+"')"
conn.execute rst1
conn.execute rst2
conn.close <

你是要新用户注册，sql="Select * From users where f_user='"&f_user1&"'" 这句不为空才应该 alert('用户名已被注册!')所以if rst.eof and rst.bof then 应该改成if not rst.eof and rst.bof then